package com.xianniu.ltc.model.vo;

import cn.hutool.core.util.NumberUtil;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.xianniu.ltc.config.PercentageConvert;
import com.xianniu.ltc.config.ThousandthConvert;
import lombok.Data;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import java.io.Serializable;
import java.math.BigDecimal;

/**
 * 商机统计VO(部门维度)
 * @Author: dingyx
 * @Date: 2021/11/2 1:26 下午
 */
@HeadRowHeight(20)
@ColumnWidth(15)
@HeadFontStyle(fontHeightInPoints = 9, fontName = "微软雅黑")
@ContentFontStyle(fontHeightInPoints = 9, fontName = "微软雅黑")
@Data
public class NicheStatisticsDeptVO implements Serializable {

    private static final long serialVersionUID = 1L;

    /**
     * 所属部门
     */
    @ExcelProperty(value = {"基础信息", "所属部门"})
    @HeadStyle(fillForegroundColor = 22)
    private String ownerDept;

    /**
     * 商机数量
     */
    @ExcelProperty(value = {"基础信息", "商机数量"})
    @HeadStyle(fillForegroundColor = 22)
    private Integer nicheNumber;
    /**
     * 赢单商机数量
     */
    @ExcelProperty(value = {"终止商机数据", "赢单商机数量"})
    @HeadStyle(fillForegroundColor = 55)
    private Integer winNicheNumber = 0;
    /**
     * 赢单商机金额
     */
    @ExcelProperty(value = {"终止商机数据", "赢单商机金额"}, converter = ThousandthConvert.class)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.RIGHT)
    @HeadStyle(fillForegroundColor = 55)
    private BigDecimal winNicheAmount = BigDecimal.ZERO;
    /**
     * 输单商机数量
     */
    @ExcelProperty(value = {"终止商机数据", "输单商机数量"})
    @HeadStyle(fillForegroundColor = 55)
    private Integer looseNicheNumber = Integer.valueOf(0);
    /**
     * 输单商机金额
     */
    @ExcelProperty(value = {"终止商机数据", "输单商机金额"}, converter = ThousandthConvert.class)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.RIGHT)
    @HeadStyle(fillForegroundColor = 55)
    private BigDecimal looseNicheAmount = BigDecimal.ZERO;
    /**
     * 签约转化率
     */
    @ExcelProperty(value = {"终止商机数据", "签约转化率"}, converter = PercentageConvert.class)
    @HeadStyle(fillForegroundColor = 55)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)
    private BigDecimal conversionRate = BigDecimal.ZERO;
    /**
     * 赢率60%-90%商机数量
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率60%-90%商机数量"})
    @HeadStyle(fillForegroundColor = 23)
    private Integer nicheNumberWinRate60_90 = Integer.valueOf(0);
    /**
     * 赢率60%-90%商机金额
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率60%-90%商机金额"}, converter = ThousandthConvert.class)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.RIGHT)
    @HeadStyle(fillForegroundColor = 23)
    private BigDecimal nicheAmountWinRate60_90 = BigDecimal.ZERO;
    /**
     * 赢率60%-90%商机金额占比
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率60%-90%商机金额占比"}, converter = PercentageConvert.class)
    @HeadStyle(fillForegroundColor = 23)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)
    private BigDecimal nicheAmountRateWinRate60_90 = BigDecimal.ZERO;
    /**
     * 赢率10%-50%商机数量
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率10%-50%商机数量"})
    @HeadStyle(fillForegroundColor = 23)
    private Integer nicheNumberWinRate10_50 = Integer.valueOf(0);
    /**
     * 赢率10%-50%商机金额
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率10%-50%商机金额"}, converter = ThousandthConvert.class)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.RIGHT)
    @HeadStyle(fillForegroundColor = 23)
    private BigDecimal nicheAmountWinRate10_50 = BigDecimal.ZERO;
    /**
     * 赢率10%-50%商机金额占比
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率10%-50%商机金额占比"}, converter = PercentageConvert.class)
    @HeadStyle(fillForegroundColor = 23)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)
    private BigDecimal nicheAmountRateWinRate10_50 = BigDecimal.ZERO;

    /**
     * 赢率10%-90%商机金额
     */
    @ColumnWidth(25)
    @ExcelProperty(value = {"跟进中商机数据", "赢率10%-90%商机金额"}, converter = ThousandthConvert.class)
    @HeadStyle(fillForegroundColor = 23)
    @ContentStyle(horizontalAlignment = HorizontalAlignment.RIGHT)
    private BigDecimal nicheAmountWinRate10_90 = BigDecimal.ZERO;
}
